Analysing Slices of Data Warehouses to Detect Structural Modifications
نویسندگان
چکیده
A source for errors in results of OLAP queries lies in neglecting changes in dimension data of Data Warehouses over time. In addition to the correct representation of such changes in temporal data warehouses it is necessary to discover such changes when they appear in the sources of a data warehouse. We propose to use data mining techniques in form of multidimensional outlier detection to discover unexpected deviations in the fact data suggesting changes in dimension data.
منابع مشابه
Performance Evaluation of the Central Stores of Hospitals Affiliated to Tehran University of Medical Sciences in 2018
Background: Due to the presence of valuable and expensive equipments in hospitals’ warehouses, scientific management and continuous evaluation plays an important role to improve the performance of warehouses and whereby the performance of hospitals’ wards. This study aimed to evaluate the performance of the central stores of hospitals affiliated to Tehran University of Medical Sciences (TUMS). ...
متن کاملA Bi-Temporal Data Warehouse Model
In data warehouses measures are analyzed along different dimensions. Although the structures of these dimensions change over time, data warehouse tools currently in use are not able to deal with these modifications in a sophisticated way. In this paper we present a bitemporal extension of the COMET metamodel. This extension enables us to represent not only the valid time of structural modificat...
متن کاملActive Data Warehouses: Complementing OLAP with Active Rules
Conventional data warehouses are passive. All tasks related to analysing data and making decisions must be carried out manually by analysts. Today's data warehouse and OLAP systems o er little support to automatize decision tasks that occur frequently and for which well established decision procedures are available. Such a functionality can be provided by extending the conventional data warehou...
متن کاملCysteamine pretreatment reduces Mg2+-free medium-induced plasticity in the CA1 region of the rat hippocampal slices
Extracellular population responses are largely preferred for the study of long-term potentiation (LTP). The effect of Mg2+-free medium on changes in activity and plasticity of Schaffer collateral-CA1 pyramidal cell synapses was examined. Hippcampal slices from cysteamine-treated (200 mg/kg, s.c.) and saline-injected (1 ml/kg, s.c.) albino rats were perfused with ACSF. Population spikes (PS) wer...
متن کاملTowards NoSQL Graph Data Warehouse for Big Social Data Analysis
Big Data generated from social networking sites is the crude oil of this century. Data warehousing and analysing social actions and interactions can help corporations to capture opinions, suggest friends, recommend products and services and make intelligent decisions that improve customer loyalty. However, traditional data warehouses built on relational databases are unable to handle this massi...
متن کامل